join employee and department table on view its not appearing in view mvc core

108

join employee and department table on view it's not appearing in view mvc core -

var query= (from x in dbquery.Employee join y in dbquery.Department on x.Emp_id equals y.Emp_id 
     where x.Emp_id==id  select new {x.Emp_id, x.Emp_name,x.Emp_Address,x.Emp_Contact, y.dept_id,y.dept_name,y.salary}).ToList(); return View(query);

Comments

Submit
0 Comments